Skip to main content

Speediful Configuration Tables

SLAM_Settings table​

The SLAM_Settings table stores configuration settings for Speediful operations. This table is automatically created during setup and contains the following key columns:

Username​

The Username field Stores the currently active Salesforce connection username. This can be set using:

EXEC dbo.SLAM_use_connection_username @username = 'your.salesforce.user@example.com'

default_exists_action​

The default_exists_action column controls the default behavior when Speediful will write to a destination object that already exists, such as during query, replication, metadata operation as well as some utility functions. This default value can be overriden for any Speediful operations using the parameter @exists_action. The value is initialized to 'drop' when the SLAM procedures are first installed in a database, but can be changed to any of the following valid values:

Valid values:

  • 'drop' - Drop the existing object and create a new one (default)
  • 'rename' - Rename the existing object by appending a timestamp suffix (format: _YYYYMMDDTHHMMSS_MMM)
  • 'fail' - Throws a SQL exception if the destination object already exists

To change the default:

UPDATE SLAM_Settings
SET default_exists_action = 'rename'
tip

Each stored procedure accepts an optional @exists_action parameter that overrides this default value when specified

mapping_template_columns​

The mapping_template_columns field controls what columns appear in the output of the SLAM_mapping_template operation, by default these are:

  • Source Object Name
  • Source Column Name
  • Transformation
  • (then all the Salesforce fields from the Salesforce object)

mapping_template_orderby​

The mapping_template_orderby field controls the sequence of the rows found in the output of the SLAM_mapping_template operation. By default these are in the sequence of the fields as they appear when looking at the object in Salesforce. This can be changed, e.g. to be the alphabetic order of the Salesforce field names.